package com.gis.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;

@Data
@TableName(value = "water_quality_data")
public class WaterQualityData {
    /*
     * springboot MyBatis无法查询出属性名和数据库字段名不完全相同的数据
     * 需要@TableField指定属性
     */
    
    @TableId(type = IdType.AUTO)
    private Integer id;

    @Schema(description = "站点ID")
    @TableField("station_id")
    private Integer stationId;
    
    @Schema(description = "盐度")
    private Float psu;
    @Schema(description = "温度")
    private Float temp;
    @Schema(description = "PH")
    private Float ph;
    @Schema(description = "溶解氧")
    @TableField("dissolved_oxygen")
    private Float dissolvedOxygen;
    @Schema(description = "悬浮物")
    private Float seston;
    @Schema(description = "需氧量")
    private Float cod;

    @Schema(description = "硝酸盐")
    @TableField("no_3")
    private Float no3;

    @Schema(description = "亚硝酸盐")
    @TableField("no_2")
    private Float no2;

    @Schema(description = "氨氮")
    @TableField("nh_3")
    private Float nh3;

    @Schema(description = "磷酸盐")
    @TableField("po_4")
    private Float po4;

    @Schema(description = "氮")
    private Float n;

    @Schema(description = "叶绿素a")
    @TableField("chla")
    private Float chla;

    @Schema(description = "石油类")
    @TableField("petroleum_class")
    private Float petroleumClass;
    @Schema(description = "硫化物")
    private Float sulfide;
    @Schema(description = "挥发酚")
    private Float voc;
    @Schema(description = "铜")
    private Float copper;
    @Schema(description = "锌")
    private Float zinc;
    @Schema(description = "铅")
    private Float lead;
    @Schema(description = "镉")
    private Float cadmium;
    @Schema(description = "汞")
    private Float mercury;
    @Schema(description = "砷")
    private Float arsenic;
    @Schema(description = "铬")
    private Float chromium;

    @Schema(description = "α-666")
    @TableField("alpha_666")
    private Float alpha666;
    @Schema(description = "β-666")
    @TableField("beta_666")
    private Float beta666;
    @Schema(description = "γ-666")
    @TableField("gama_666")
    private Float gama666;
    @Schema(description = "δ-666")
    @TableField("delta_666")
    private Float delta666;

    @Schema(description = "滴滴涕p'p-DDE")
    @TableField("pp_dde")
    private Float ppdde;
    @Schema(description = "滴滴涕p'p-DDD")
    @TableField("pp_ddd")
    private Float ppddd;
    @Schema(description = "滴滴涕o'p-DDT")
    @TableField("op_ddt")
    private Float opddt;
    @Schema(description = "滴滴涕p'p-DDT")
    @TableField("pp_ddt")
    private Float ppddt;

    @Schema(description = "多环芳烃-苊")
    @TableField("pah_acl")
    private Float pahacl;

    @Schema(description = "多环芳烃-苊烯")
    @TableField("pah_ac")
    private Float pahac;

    @Schema(description = "多环芳烃-苯并芘")
    @TableField("pah_an")
    private Float pahan;

    @Schema(description = "多环芳烃-苯并(a)蒽")
    @TableField("pah_baa")
    private Float pahbaa;

    @Schema(description = "多环芳烃-苯并(e)芘")
    @TableField("pah_bep")
    private Float pahbep;

    @Schema(description = "多环芳烃-苯并(b)荧蒽")
    @TableField("pah_bbfa")
    private Float pahbbfa;

    @Schema(description = "多环芳烃-苯并(g,h,i)苝")
    @TableField("pah_bghip")
    private Float pahbghip;

    @Schema(description = "多环芳烃-苯并(k)荧蒽")
    @TableField("pah_bkfa")
    private Float pahbkfa;

    @Schema(description = "多环芳烃-䓛")
    @TableField("pah_chr")
    private Float pahchr;

    @Schema(description = "多环芳烃-二苯并(a, h)e蒽")
    @TableField("pah_dbaha")
    private Float pahdbaha;

    @Schema(description = "多环芳烃-荧蒽")
    @TableField("pah_fa")
    private Float pahfa;

    @Schema(description = "多环芳烃-芴")
    @TableField("pah_fl")
    private Float pahfl;

    @Schema(description = "多环芳烃-茚并(1, 2, 3-cd)芘")
    @TableField("pah_ip")
    private Float pahip;

    @Schema(description = "多环芳烃-萘")
    @TableField("pah_na")
    private Float pahna;

    @Schema(description = "多环芳烃-菲")
    @TableField("pah_phe")
    private Float pahphe;

    @Schema(description = "多环芳烃-芘")
    @TableField("pah_py")
    private Float pahpy;

    private Float pcb28;
    private Float pcb52;
    private Float pcb101;
    private Float pcb81;
    private Float pcb123;
    private Float pcb118;
    private Float pcb114;
    private Float pcb153;
    private Float pcb105;
    private Float pcb138;
    private Float pcb126;
    private Float pcb167;
    private Float pcb156;
    private Float pcb157;
    private Float pcb180;
    private Float pcb169;
    private Float pcb189;

    @Schema(description = "潮汐状态")
    @TableField("tide_status")
    private String tideStatus;

    @Schema(description = "年份")
    private Integer year;
    @Schema(description = "季度")
    private String season;
}
